🕷️️ Job Radar • SCRAPING

upwork.com 🟡 2026-05-28

🔹 UK Accounting Firms & Officers Dataset Extraction
👤 Client: 🇵🇰 Pakistan Member since 2023-11-30
💰 Price: ****
🚩 Problem: Extraction and enrichment of corporate officer data from large-scale Companies House bulk dumps and API endpoints.
📦 Existing: Companies House Basic Company Data Dump (CSV), Companies House API Key

Specifications:

[Target] UK accounting firms (SIC codes: 69201, 69202, 69203)
[Method] Bulk CSV merging, SIC filtering, /officers API endpoint querying
[Stack] Python (Pandas) or Node.js
[Security] API rate-limit throttling (600 requests / 5 minutes)
[Format] CSV or Excel
[Target] Data fields: Company Number, Company Name, SIC Code, Registered Address, Officer Name, Role

Workflow:

1. Merge and filter multi-part Companies House CSV dumps by SIC classes.
2. Deduplicate company list.
3. Execute throttled API requests to /officers endpoint for filtered companies.
4. Extract active directors, partners, and PSCs.
5. Consolidate results into final structured file.